home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / oracl / sep95 / perkt101.gif < prev    next >
Graphics Interchange Format  |  1996-11-16  |  167KB  |  805x803  |  4-bit (16 colors)
Labels: text | screenshot | number | font | parallel | line | pattern | rectangle
OCR: ABLE 1: Results from our tests show the scalability of Oracle's parallel query option across degrees of parallelism and numbers of CPUs 3 CPUS 2 CPUs Elapsed Throughput CPU % change Seconds (% change) Elapsed Seconds % change) Throughput CPU Queries Degree Seconds (% change) % change Seconds (% change) Aggregate 1 207 146.94 Not Tested 3 60 1-71.0) +245.0 118.96 [-19.0) Not Tested 5 46 (77.8) +350.0 119.13 (-18.9) 70 (66.2 +195.7 119.10 (-18.9) 7 50 (-75.8] 119.11 (-18.9) +228.6 10 42 [79.7) +314.0 63 {69.6] 118.70 (-19.2) +392.9 119.08 (-19.0) 62 |70.0 +233.9 119.45 (-18.7) 15 42 (79.7) +392.9 119.35 (-18.8) 60 (71.0) +245.0 118.43 (-19.4] Distinct 143 81.76 Not Tested 13 46 | 67.8) 104.95 (+28.4) Not Tested 5 63 [55.9) +210.9 -127.0 106.34 (+30.1) 57 1-60 1) +150.9 107.01 (+30.9) 61 [57.3) +134.4 102.21 (+25.0) 57 (-60 1) +150.9 102.51 (+25.4) 10 38 ( 73.4) +276.3 06.54 (+30.3) 56 60 8 +155.4 107.70 (+31.7) 15 36 [74.8) +297.2 103.16 (+26.2) 53 (62.9) +169.8 101.43 (+24.1) Group By: 145 85.72 Not Tested 3 52 [64.1) +178.8 109.39 (+27.6) Not Tested 5 52 [-64.1) +178.8 110.93 (+29.4) 69 [-52.4) +110.1 110.41 (+28.8) 7 48 [-66.9) +202.1 108.58 (+26.7) 65 (-55.2) +123.1. 106,46 (+24.2) 10 51 (-64.8) +184.3 69 (-52.4) +110.1 111.43 (+30.0) 15 53 (-63.4) 11.61 (+30.2) +173.6 107.55 (+25.5) 70 (51.7) +107.1 105.66 (+23.3] Merge 932 3 502 (-46.1) 832.37 902.29 ( +8.4| Not Tested +85,7 927.92 (+11.5) Not Tested 5 383 [58.9 +143.3 478 1-48.7) ¥95.0 905.72 ( +8.8) 347 (-62.8) +168.6 943.23 |+13.3) 473 1-49.2) $97.0 911:58 | +9.5) 10 331 (64.5) +181.6 947.43 (+ 13.8) 472 (49-4) ¥97.5 911.61 | +9.5) 15 327 (64 9) 4185.0 948.16 (+13.9) 485 [-48.0) 492.2 916.64 [+10.1). Nested 588 522.41 Not Tested 3 201 (-65.8) +192.5 523.14 { +0.1) Not Tested 5 182 (69.0] +223.1 525.38 | +0.6) 268.(54.4] 270 (-54.1] +119.4 522.79 [ +0.1) 7 83 (68.9) +221.3 526.24 [+0.7) +117.8 524.59 [ +0.4) 10 184 (-68.7) +219.6 525.58 [ +0.6) 271 (53.9] +117.0 523.65 [ +0.2) 15 184 (68.7) +219.6 529.40 [ +1.3) 273 (53.6] +115.4 525.72 [ +0.6) Order By 606 540.34 Not Tested 3 219 163.9 +176.7 554.64 [ +2.6) 214 (-64.7) +183.2 568.88 [ +5.3 Not Tested 319 (-47.4) +90.0. 603.59 (+11.7) 7 191 ( 68.5] +217.3 553.01 ( +2.3) 293 151 .7 +106.8 554.58 ( + 2,6] 193 (-68.2) +214.0 549.72 [ +].7) 283 ( 53.3) +114.1 547.10 ( +1.3] 15 194 (-68.0) +212.4 550.54 ( + 1.9) 287 (52.6] 4111.1 548.60 ( +1.5) Scan 1 586 520.84 Not Tested 3 200 (65.9] +193.0 520.43 ( 0.1] Not Tested 5 214 (63.5] +173.8 523.83 ( +0.6] 274 ( 53.2] +113.9 522.69 (+0.4] 7 184 68.6] +218.5. 524.65 ( +0.7) 277 (-52.7] +111.6 531.11 ( +2.0] 10 185 (68.4] +216,8 523.84 ( +0.6] 275 (53.1) +113.1 525.11 ( +0.8) 1.5 181.(-69.1] +223.8 525.42 ( +0.9) 268 (54.3] +118.7 524.56 [ +0,7)